﻿CREATE TABLE [dbo].[ImportInfo] (
    [ID]                      INT             IDENTITY (1, 1) NOT NULL,
    [Code]                    INT             NOT NULL,
    [CustomerCompany]         NVARCHAR (50)   NULL,
    [CustomerName]            NVARCHAR (50)   NULL,
    [CustomerPhone]           NVARCHAR (50)   NULL,
    [ShipCompany]             NVARCHAR (50)   NULL,
    [Voyage]                  NVARCHAR (50)   NULL,
    [BillNumber]              NVARCHAR (50)   NULL,
    [ProductName]             NVARCHAR (200)  NULL,
    [ProductWeight]           NVARCHAR (50)   NULL,
    [ProductVolume]           NVARCHAR (50)   NULL,
    [Port]                    NVARCHAR (50)   NULL,
    [Warehouse]               NVARCHAR (50)   NULL,
    [ArrivedDate]             DATE            NULL,
    [LeaveDate]               DATE            NULL,
    [ExpiredDate]             DATE            NULL,
    [RecievedBillDate]        DATE            NULL,
    [ExchangeBillDate]        DATE            NULL,
    [ExchangeBillAddress]     NVARCHAR (50)   NULL,
    [CheckNumber]             NVARCHAR (50)   NULL,
    [EverythingReadyDate]     DATE            NULL,
    [BigPassDate]             DATE            NULL,
    [CustomDate]              DATE            NULL,
    [BoxSize]                 NVARCHAR (50)   NULL,
    [BoxNumber]               NVARCHAR (50)   NULL,
    [CustomCompany]           NVARCHAR (50)   NULL,
    [ManualNumber]            NVARCHAR (50)   NULL,
    [OhterProveNumber]        NVARCHAR (200)  NULL,
    [ContractNumber]          NVARCHAR (50)   NULL,
    [LetPassDate]             DATE            NULL,
    [InvoiceDate]             DATE            NULL,
    [PortPlanDate]            DATE            NULL,
    [IsTransportFaster]       BIT             NULL,
    [DeliveryDate]            DATE            NULL,
    [TruckCompany]            NVARCHAR (50)   NULL,
    [CheckDeclarationDate]    DATE            NULL,
    [CustomerNumber]          NVARCHAR (50)   NULL,
    [Quantity]                INT             NULL,
    [IsCompleted]             BIT             NULL,
    [ShipArrivedDate]         DATE            NULL,
    [CreatedDate]             DATETIME        NOT NULL,
    [CreatedBy]               INT             NOT NULL,
    [ModifiedDate]            DATETIME        NOT NULL,
    [Modifiedby]              INT             NOT NULL,
    [Remark]                  NVARCHAR (2000) NULL,
    [AnimalCheckNumber]       NVARCHAR (50)   NULL,
    [DrawbackDeclarationDate] DATE            NULL,
    [DrawbackTaxDate]         DATE            NULL
);

